package com.yx.sql.helper;


import com.yx.common.core.domain.entity.DbTableColumn;

import java.sql.SQLException;
import java.util.List;
import java.util.Map;

public abstract class Helper {

    /**
     * 查询表信息
     */
    public abstract List<DbTableColumn> queryTables(Object jdbcTemplate, String schema) throws SQLException;

    /**
     * 查询表的列
     */
    public abstract List<DbTableColumn> queryTableColumns(Object jdbcTemplate,String schema,String tableName) throws SQLException;

    /**
     * 查询表的返回map
     */
    public abstract Map<String,String> queryColumnMap(Object jdbcTemplate,String schema,String tableName) throws SQLException;

    /**
     *@desc 执行查询脚本
     *@params [jdbcTemplate, sql]
     *@author baolian.sun
     *@date 2023/5/5
     */
    public abstract List<Map<String, Object>> findSQl(Object jdbcTemplate, String sql) throws SQLException;




}
